/**
  *Created by caojie on 16/3/25.
 **/


var tableName = 'user_history_info';
var user = {
    insert: 'INSERT INTO '+tableName+'(search_type,user_id,search_value) Values(\'address\',',
    insertP: 'INSERT INTO '+tableName+'(search_type,user_id,search_value) Values(\'park\',',
    insertPOI: 'INSERT INTO '+tableName+'(search_type,user_id,search_value) Values(\'POI\',',
    queryAll: 'select * from '+tableName+'',
    queryByUser: 'select * from '+tableName+' where user_id=',

    update: 'update '+tableName+' set name=?, age=? where id=?',
    delete: 'delete from '+tableName+' where id=?',
    queryByCondition: 'select * from '+tableName+' where '
};

module.exports = user;
